select * from products where pro_name like '%color%ment%' or pro_des like '%color%ment%'union all select * from products where (pro_name like '%color%' or pro_des like '%color%') or(pro_name like '%ment%' or pro_des like '%ment%') and (pro_name not like '%color%ment%' or pro_des not like '%color%ment%')

Multi-color Sweetheart Layered Organza Quinceanera Dresses

Wine Red Taffeta Beaded Dresses for Quince with Pick-ups

Olive Green Floor-length Taffeta Dress for Quinceaneras

Multi-color Organza Quinceanera Gown Dresses with Ruches

Pink Straps Tulle Beaded Floor-length Sweet Sixteen Dresses

Hot Pink Strapless Tulle Sweet Sixteen Dresses with Beading

Dark Purple Ruched Taffeta Sweet 16 Dresses with White Belt

Multi-color Strapless Sweet Sixteen Dresses with Pick-ups

Watermelon Floor-length Taffeta Embroidery Quinceanera Dresses

Fuchsia Taffeta Beaded Quinceanera Gown Dresses with Pick-ups

Floral Embellishment Organza Sweet Sixteen Dress in Spring Green

Off the Shoulder Organza Quinces Dress with Floral Embellishment

Best Hand Made Flowers One Shoulder Sweet 15 Dresses in Green

Simple Organza Strapless Dresses for Quince with Beaded Bowknot

Customize Embroidery Pick-ups Quinceanera Dresses Floor-length

Navy Blue and White Ball Gown Sweet Sixteen Dress with Pick-ups

Colorful Sweetheart Organza Quinceanera Party Dress with Ruffles

Taffeta and Tulle Pick-ups Sweet 15 Dresses with Embroidery 2014

Stylish Strapless Beading Embroidery Quinces Dress with Pick-ups

Beautiful Fuchsia and Aqua Blue Dresses for Quince with Bowknot

Ball Gown Embroidery Sweetheart Quinceanera Dress with Ruffles

White and Gray Organza Embroidery Dress for Sweet 15 Discount

Formal Strapless Beading Dress for Quince in Burgundy and White

Multi-colored Ruffles One Shoulder Sweet 15 Dresses with Beading

Sophisticated Appliques Brown Quinceanera Party Dress in Taffeta

Newest Two-toned Strapless Organza Dress for Quince with Ruffles

Spring Green Ruffles Sweetheart Quinceanera Gowns with Beading

Embroidery Strapless Quinceanera Party Dress in Purple and White

Attractive Olive Green and White Dress for Quince with Embroidery

Latest Rose Pink Ball Gown Appliques Sweet 16 Dress with Ruches